MySql-query to update filenames

[pmquist]

I would like to have help with a sql query to change filenames on attached files in vB5. Today the attachments are named with strange characters and i would like an upgrade query where this is made "normal" again.

For example i would like

ö to equal ö

Ã¥ to equal ?

ä to equal ä

The file this is stored is in yyy_attach and the fieldname is "filename"

Regards / PerOla

[Dave]

Looks like vBulletin 5 doesn't correctly decode the characters.

You could run queries such as:
UPDATE yyy_attach SET filename = REPLACE(filename, "ë", "ë")

[pmquist]

Originally Posted by Dave

Looks like vBulletin 5 doesn't correctly decode the characters.

You could run queries such as:
UPDATE yyy_attach SET filename = REPLACE(filename, "ë", "?")

Thank You! I will try that.

--------------- Added [DATE]1459775257[/DATE] at [TIME]1459775257[/TIME] ---------------



Regards / PerOla