Re: [AOLSERVER] chinese characters and oracle driver

2011-07-19 Thread Fenton, Brian
. Brian - Reply message - From: Janine Ohmer jan...@furfly.net To: AOLSERVER@LISTSERV.AOL.COM AOLSERVER@LISTSERV.AOL.COM Subject: [AOLSERVER] chinese characters and oracle driver Date: Mon, Jul 18, 2011 8:27 pm Make sure that any vars set in your shell environment that relate

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-19 Thread Fenton, Brian
From: Fenton, Brian Sent: 19 July 2011 09:12 To: AOLserver Discussion Subject: Re: [AOLSERVER] chinese characters and oracle driver Also, try first solving the problem of reading from the database. So if you have some data in a table that you know is correctly stored, try a sql query from

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-18 Thread Brad Chick
I don't think it's tcl at this point. I can see that aolserver/tcl can bring in the unicode characters and return them to the client 'as is'. And you can see what encoding system tcl is using via this command as well: [encoding system] which shows that tcl is using UTF-8, which is what is

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-18 Thread Fenton, Brian
...@chickcentral.com] Sent: 18 July 2011 16:19 To: AOLSERVER@LISTSERV.AOL.COM Subject: Re: [AOLSERVER] chinese characters and oracle driver I don't think it's tcl at this point. I can see that aolserver/tcl can bring in the unicode characters and return them to the client 'as is'. And you can see what encoding

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-18 Thread Brad Chick
I just grabbed the latest oracle driver from cvs and you are right: there is no explicit support for either NCHAR or NVARCHAR2 - which oracle requires to store unicode characters. So, I will try to update the driver and report back. Thanks -- AOLserver - http://www.aolserver.com/ To Remove

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-18 Thread Brad Chick
Well, I reached an impasse. I grabbed the latest source from CVS, added support for the 2 datatypes (NCHAR, NVARCHAR2), and recompiled. Then, I turned on debugging for the driver. The logs look great. The driver constructs the queries appropriately: e.g.

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-18 Thread Janine Ohmer
Make sure that any vars set in your shell environment that relate to this are also set in your nsd wrapper script. I wish I knew for sure if that is enough for them to be effective, but I don't. I vaguely recall that the C API the driver uses is called Pro-C on the Oracle side - you might

[AOLSERVER] chinese characters and oracle driver

2011-07-15 Thread Brad Chick
I am having trouble getting Chinese characters in/out of oracle with AOLserver. Here is my stack: Oracle 11g TCL 8.5 AOLserver 4.51 Oracle Driver version 2.7 The existing database has a database character set of WE8ISO8859P1. But we are using NCHAR and NVARCHAR2 datatypes to store Unicode

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-15 Thread Peter Sadlon
encoding: http://tcl.activestate.com/man/tcl8.5/TclCmd/encoding.htm Like I said, just a shot in the dark at what the issue may be. _Peter Date: Fri, 15 Jul 2011 16:01:19 -0400 From: b...@chickcentral.com Subject: [AOLSERVER] chinese characters and oracle driver To: AOLSERVER@LISTSERV.AOL.COM

Re: [AOLSERVER] chinese characters and oracle driver

2011-07-15 Thread Janine Ohmer
the issue may be. _Peter Date: Fri, 15 Jul 2011 16:01:19 -0400 From: b...@chickcentral.com Subject: [AOLSERVER] chinese characters and oracle driver To: AOLSERVER@LISTSERV.AOL.COM I am having trouble getting Chinese characters in/out of oracle with AOLserver. Here is my stack