Geek Answers Handbook

UTF-8 character encoding in SQL

I am trying the Bullzip Access to mySQL app in an access database that has special characters like é and ä. The application allows you to specify the UTF-8 encoding, but in the resulting SQL file I get "Vieux CarrÃ" instead of "Vieux Carré".

I tried to open the SQL file in UltraEdit and perform the UTF-8 conversion, but it does not solve this problem, since I assume it converts "Ã ©" and never sees "é"?

What is Good ™ for this?

0
source share
1 answer

The problem is converting UTF-8 to Unicode in or from Access. Access, like SQL Server, can only save data in ASCII or Unicode (UTF-16) format (when Unicode is disabled). To ensure that the setpoint is stored correctly, you will need to convert it to Unicode for storage and convert it back to UTF-8 when you extract it. You can use the StrConv function for this purpose.

+1
source

More articles:


All Articles