Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-17 Thread Dossy Shiobara
On 2008.04.17, Dossy Shiobara <[EMAIL PROTECTED]> wrote: > >1.1.2 Pasting some Chinese characters via SQL Server Management > >Studio Express > > I used this, which I hope is equivalent to your Java program: > > INSERT INTO multibytetest (value) > SELECT CHAR(230) + CHAR(144) +

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-17 Thread Dossy Shiobara
On 2008.04.17, Rajesh Nair <[EMAIL PROTECTED]> wrote: > Here are the steps to replicate the problem This is great, thanks! > 1. you need a table with some multibyte characters in it. > > You can do this either by > >1.1.1 create table multibytetest (value nvarchar(200)) I just came across

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-17 Thread Rajesh Nair
To: AOLSERVER@LISTSERV.AOL.COM Cc: Rajesh Nair Subject: Re: [AOLSERVER] [ns_db and multibyte support] On 2008.04.16, Dossy Shiobara <[EMAIL PROTECTED]> wrote: > I'll be fixing nsfreetds with the FreeTDS 0.64 version, then once we > agree everything "works" as expec

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-16 Thread Dossy Shiobara
On 2008.04.16, Dossy Shiobara <[EMAIL PROTECTED]> wrote: > I'll be fixing nsfreetds with the FreeTDS 0.64 version, then once we > agree everything "works" as expected, I'll try rolling forward to > FreeTDS 0.82. > > Rajesh, thanks for your interest. Okay, after a bit of fixing up, I've gotten my

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-16 Thread Dossy Shiobara
On 2008.04.15, Rajesh Nair <[EMAIL PROTECTED]> wrote: > Dossy wrote: > > I have a bunch of uncomitted changes/bugfixes in my local copy, that > > I haven't checked in as I have no environment to test the changes > > against. > > > > I plan on setting up a SQL Server 2005 Developer Edition (which i

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-15 Thread Rajesh Nair
-Original Message- From: AOLserver Discussion [mailto:[EMAIL PROTECTED] On Behalf Of Dossy Shiobara Sent: Tuesday, April 15, 2008 7:10 PM To: AOLSERVER@LISTSERV.AOL.COM Subject: Re: [AOLSERVER] [ns_db and multibyte support] On 2008.04.15, Rajesh Nair <[EMAIL PROTECTED]> wrote: >

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-15 Thread Dossy Shiobara
On 2008.04.15, Rajesh Nair <[EMAIL PROTECTED]> wrote: > Trying to isolate the problem area, I tried using jTDS JDBC driver > (which is the Java implementation of FreeTDS) to connect to the same > SQL server and it behaved correctly with just one login request with > correct COLLATION environment va

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-15 Thread Rajesh Nair
Behalf Of Dossy Shiobara Sent: Tuesday, April 15, 2008 12:53 AM To: AOLSERVER@LISTSERV.AOL.COM Subject: Re: [AOLSERVER] [ns_db and multibyte support] On 2008.04.15, Rajesh nair <[EMAIL PROTECTED]> wrote: > Could the second login request be a bug of nsfreetds driver? It could either be a p

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-14 Thread Dossy Shiobara
On 2008.04.15, Rajesh nair <[EMAIL PROTECTED]> wrote: > Could the second login request be a bug of nsfreetds driver? It could either be a problem in the nsfreetds driver or the FreeTDS library itself. Unfortunately, I no longer have a Sybase or SQL Server environment to test changes/fixes to nsfr

Re: [AOLSERVER] [ns_db and multibyte support]

2008-04-14 Thread Rajesh nair
-- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank. * o * *

Re: [AOLSERVER] ns_db and multibyte support

2008-04-09 Thread Rajesh nair
Found the problem cause and the solution Firing the following mysql command lets me get the right result from mysql /*set character_set_results = NULL */That is after firing "use fresh" /* ** set sql1 "set character_set_results = NULL"; ns_db exec $db $sql1 */ This is what mysql JDBC driv

Re: [AOLSERVER] ns_db and multibyte support

2008-04-09 Thread Rajesh nair
Darren, The Content-Type is set to *text/html; charset=utf-8*. Though the way I have done is /*ns_set put [ns_conn outputheaders] "Content-Type" "text/html; charset=utf-8" */I tried the meta tag equivalent too but no luck! /* */-- Rajesh Nair/* */ Darren Ferguson wrote: I had similar issues

Re: [AOLSERVER] ns_db and multibyte support

2008-04-09 Thread Darren Ferguson
I had similar issues and in the head component of my adp being generated i had to add the following: Once that was added the pages were rendered correctly. Respectfully, Darren Ferguson Rajesh nair wrote: Oops , forgot to attach the adp -- Rajesh Nair Rajesh Nair wrote: Bas, Apologies f

Re: [AOLSERVER] ns_db and multibyte support

2008-04-09 Thread Rajesh nair
Oops , forgot to attach the adp -- Rajesh Nair Rajesh Nair wrote: Bas, Apologies for the delayed response! Our setup is a complex set of components with a java component inserting records and tcl based RESTful service fetching the records back. I have isolated this issue to a t

Re: [AOLSERVER] ns_db and multibyte support

2008-04-09 Thread Rajesh nair
Bas, Apologies for the delayed response! Our setup is a complex set of components with a java component inserting records and tcl based RESTful service fetching the records back. I have isolated this issue to a tcl script and am sending this out to replicate the issue 1. My MySQL version i

Re: [AOLSERVER] ns_db and multibyte support

2008-04-03 Thread Jade Rubick
I echo Bas here. The only issue I've ever had is when writing to or reading from files. You have to specify the encoding. Jade On Thu, Apr 3, 2008 at 3:14 PM, Cynthia Kiser <[EMAIL PROTECTED]> wrote: > On Apr 2, 2008, at 5:42 PM, Bas Scheffers wrote: > > > > > The only issues I ever faced was (C

Re: [AOLSERVER] ns_db and multibyte support

2008-04-03 Thread Bas Scheffers
On 04/04/2008, at 8:44 AM, Cynthia Kiser wrote: It never occurred to me to try parsing this with Tcl instead. Is there an AOLserver or straight Tcl module I should be using to parse pseudo-CSV? Or is the answer keep it simple and just read lines and split on ยก with 'split'? Tcl lib has a CSV

Re: [AOLSERVER] ns_db and multibyte support

2008-04-03 Thread Michael A. Cleverly
On Thu, Apr 3, 2008 at 4:14 PM, Cynthia Kiser <[EMAIL PROTECTED]> wrote: > H CSV + "stupid Windows encoding". Bas perhaps you have just what I > need for a character set issue. I have a data file - actually delimited by > upsidedown exclamation points, not commas. > It never occurred to me t

Re: [AOLSERVER] ns_db and multibyte support

2008-04-03 Thread Cynthia Kiser
On Apr 2, 2008, at 5:42 PM, Bas Scheffers wrote: The only issues I ever faced was (CSV) file uploads, where the data needed to be extracted and put into the database. This could contain any encoding without me knowing. In practice it only ever contained stupid Windows encoding, so I assume

Re: [AOLSERVER] ns_db and multibyte support

2008-04-02 Thread Bas Scheffers
My own special recipe is to not worry about it! :) If you have a green-fields project with no existing database, all you do is: - Make sure the database is UTF-8 - Set the encoding to UTF-8 for any page returned to the client. (if you have a form on a page and the page was set to UTF-8, the

Re: [AOLSERVER] ns_db and multibyte support

2008-04-02 Thread Tom Jackson
Just to back up what Bas said, AOLserver has been, and probably still is, light years ahead of most systems when handling encoding issues. Tcl is essentially UTF-8, which is multi-byte. But there are so many issues involved, you have to become something of an expert. The good news is that AOLs

Re: [AOLSERVER] ns_db and multibyte support

2008-04-02 Thread Bas Scheffers
Some questions to help us, and maybe give you some hints as to what might be wrong. How did you determine the fact that the value isn't a correct Tcl string? What encoding is the database in? (UTF-8?) Are you 100% sure the data in the database is actually correct? I wouldn't think you w

[AOLSERVER] ns_db and multibyte support

2008-04-02 Thread Rajesh nair
Hi all, We have an existing Tcl service which provides the data from mysql to clients as an HTML table. We have some records in mysql with multibye characters which are not being rendered correctly. Simple ns_db getrow does not return me the correctly encoded data form database. I have the