Problems Regarding Charset (latin1/UTF-8)

[asterus]

Hello there...

I'm here to ask your help... I'm from Brazil and here we use portuguese characters such as àáãâä...

Here I have NWNX installed working with MySQL. I have configurated MySQL to work with charset latin1 and collation latin1, for all tables storage...

I have repaired that always when I try to get a value from my database (i.e.: using 'SELECT data FROM table WHERE clause=1'), when MySQL have non-english characters the NWNX give me an truncated result, starting from this character.

In example, when i use SQLExec to send and fetch the following data, what stays on odbc log is:

INSERT INTO table (id, data) VALUES (1, 'antárius');
Successful...


SELECT data FROM table where id = 1;
Returns: 'ant'


What should I do?


I guess it's a problem regarding iso8859-1 / win1252 / latin1 / unicode / utf-8 charsets, but I don't know what to do.


Thanx.


o Got request: INSERT INTO players (id, name) VALUES 1, 'Name Báàãâä';
o Got request: SELECT name FROM players WHERE id = 1
o Sent response (6 bytes): Name B
_________________
"What we do in life echoes in eternity." (Maximus Decimus)

Dan Lake

[ShaDoOoW]

I using utf8 and its fine.
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[asterus]

[ShaDoOoW]

jasně že jo

translation: of course I do
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[asterus]

[asterus]

Using UTF-8 as default charset:


NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org

o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using MySQL connection.
o Hooking SCO....hooked at 5d5830
o Hooking RCO....hooked at 5d5710
o Connect successful.
o Got request: CREATE TABLE `kheart_bd`.`testefucked` (`player` varchar(64) NOT NULL default '~', `tag` varchar(64) NOT NULL default '~', `name` varchar(64) NOT NULL default '~', `val` text, `expire` int(11) default NULL, `last` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, KEY `idx` (`player`,`tag`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
o Got request: SELECT player FROM testefucked WHERE player='~' AND tag='MODULE' AND name='Teste'
o Sent response (0 bytes):
o Got request: INSERT INTO testefucked (player,tag,name,val,expire) VALUES('~','MODULE','Teste','astárus',0)
o Got request: SELECT val FROM testefucked WHERE player='~' AND tag='MODULE' AND name='Teste'
o Sent response (3 bytes): ast


... not good, again
_________________
"What we do in life echoes in eternity." (Maximus Decimus)

Dan Lake