| View previous topic :: View next topic |
| Author |
Message |
Gryphyn
Joined: 20 Jan 2005
Posts: 431
|
 Posted: Wed Jan 03, 2007 12:52 Post subject: |
 |
|
| amphiprion wrote: | Like i said previously, the problem occurs for me (and others) ONLY if i insert data using a MySQL client (phpmyadmin, etc...)
But like you, i don't have any problem if i display a string previouly inserted by nwnx. |
| Quote: |
But the most important snippet is:
Character set issues affect data storage, but also communication between client programs and the MySQL server. If you want the client program to communicate with the server using a character set different from the default, you'll need to indicate which one. For example, to use the utf8 Unicode character set, issue these statements after connecting to the server:
SET NAMES 'utf8';
SET CHARACTER_SET utf8;
To change the connection charset permanently to UTF-8, add the following line in the [mysqld] section:
[mysqld]
init-connect='SET NAMES utf8'
|
Using the MySQL client -- ANY MySQL client --, you'll need to specify that the data you are inserting is encoded as UTF-8, to get it out in UTF-8 (otherwise it will default/convert to UCS-2)
Note: UCS-2 while used by MySQL internals cannot be used as a client character set.
Cheers
Gryphyn |
|
| Back to top |
|
 |
Arvirago
Joined: 17 Nov 2006
Posts: 15
|
| Posted: Mon Sep 10, 2007 21:26 Post subject: |
|
|
I have the same problem.
I have these books that display a GUI when used, and get the content of the book from a mysql table via nwnx4.
I want to write the text for the books from the web, but when I show them in NWN2 (using the GUI or using SendMessage) all accents go wrong.
I have also tried different configurations for my DB/table, latin1, UTF8, etc. but to no good.
I'll try to use amphiprion's fix meanwhile. Thx. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
