logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Problems Regarding Charset (latin1/UTF-8)

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support
View previous topic :: View next topic  
Author Message
asterus



Joined: 28 Jan 2008
Posts: 5
Location: Brazil

PostPosted: Sat Sep 26, 2009 18:50    Post subject: Problems Regarding Charset (latin1/UTF-8) Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
ShaDoOoW



Joined: 20 Aug 2005
Posts: 584

PostPosted: Sun Sep 27, 2009 18:11    Post subject: Reply with quote

I using utf8 and its fine.
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect
Back to top
View user's profile Send private message
asterus



Joined: 28 Jan 2008
Posts: 5
Location: Brazil

PostPosted: Sun Sep 27, 2009 20:32    Post subject: Reply with quote

ShaDoOoW wrote:
I using utf8 and its fine.


Are you using non english characters such à á ã â ä ?
_________________
"What we do in life echoes in eternity." (Maximus Decimus)

Dan Lake
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
ShaDoOoW



Joined: 20 Aug 2005
Posts: 584

PostPosted: Sun Sep 27, 2009 21:53    Post subject: Reply with quote

jasně že jo Wink

translation: of course I do
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect
Back to top
View user's profile Send private message
asterus



Joined: 28 Jan 2008
Posts: 5
Location: Brazil

PostPosted: Mon Sep 28, 2009 5:03    Post subject: Reply with quote

ShaDoOoW wrote:
jasně že jo Wink

translation: of course I do


The best I can:


Using Latin-1 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;
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 (7 bytes): ast?rus

... no way, again Sad
_________________
"What we do in life echoes in eternity." (Maximus Decimus)

Dan Lake


Last edited by asterus on Mon Sep 28, 2009 5:09; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
asterus



Joined: 28 Jan 2008
Posts: 5
Location: Brazil

PostPosted: Mon Sep 28, 2009 5:08    Post subject: Reply with quote

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 Sad
_________________
"What we do in life echoes in eternity." (Maximus Decimus)

Dan Lake
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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