Forum Moderators: open
What character set and collation do I need to set for MySql tables. Also, should I set my exe to import with utf8 options or something like that.
I have been trying it since a couple of days now and its become real frustrating. Any inputs would be appreciated.
MySql 4.1 supports UTF-8 charset/collation, that is more than 650 languages. I have tried it, it works great... although a mod told me that Mysql 4.1 has still some few bugs but it will fully functional in MySql 5.
Read also [webmasterworld.com...] explaining how to work in a UTF-8 free-hassle environment.
If you use an older version, then you need a specify a different charset for each language, that is having a table for each language with its own charset.... A nightmare!
Hope it helps.
Tomda
I use Mysql 5. I will check up the link you provided.
My question is about importing UTF8 characters into MySql via 2 methods. One via MySql import feature and second via inserting using a tool created in Visual Basic.
I am trying to insert the character Č which has chararacter code as Č
- Using MySql import feature, it looks perfect Č when I view it using MySql Front.
- Importing it using the exe tool created by me, it looks like this Č. (I need to import using this tool)
I have no idea why it is happening like this. I am even importing it as utf8.
Any inputs?
If yes check that you set the second argument which deals with unicode output.
Google for fso.CreateTextFile Method and you will see a full reference.
