[freetds] column_unicodedata considered harmful

Lowden, James K LowdenJK at bernstein.com
Thu Apr 3 10:14:09 EST 2003


> From: Brian Bruns [mailto:camber at ais.org]
> Sent: April 3, 2003 9:11 AM
> 
> Specifically in dblib we need to 
> test dbdatlen(), which i think will be obvious, and 
> dbcollen() which is 
> anybodys guess, and I think this is the important point.

Hi Brian, 

Thanks for the offer.  I'll probably work up a unittest, but being more of a
lazy programmer than an eXtreme Programmer, I'd rather do that toward the
end of my seismic shift.  

UTF-8 issues with Sybase:

1.  Are metadata stored in UTF-8?  Can table/column names contain accented
characters?  If it does, what's the value of column_namelen in
tds_process_col_name()?  
2.  How wide is a varchar(30) column if the Sybase charset is UTF-8?  

If you could poke around with gdb, I'm sure the information would be
valuable.  

Moving, ugh.  

--jkl



> 
> Brian
> 
> On Wed, 2 Apr 2003, Mark J. Lilback wrote:
> 
> > At 12:16 PM -0500 4/2/2003, Lowden, James K wrote:
> > >  > From: ZIGLIO Frediano 
> [mailto:Frediano.Ziglio at vodafoneomnitel.it]
> > >  > Currently my Sybase server (only a test server) is 11.9.2. So
> > >>  it do not
> > >>  support utf8. I think someone can test the behavior of Sybase
> > >>  using utf8 data.
> > >>  - if server is utf8 and return data in iso8859-1 
> (iso_1) how it return
> > >>  column sizes?
> > >>  - if server is iso_1 (reinstallation required?) how it return
> > >>  column sizes?
> > >>  - test unichar and univarchar columns
> > >>  - test longvarbinary TDS type with UTF16 inside (does server
> > >>  use UCS2 or real UTF16?)
> > >
> > >These would be useful and interesting tests.  I'm in the 
> same boat you are
> > >atm with 11.9.2.
> > 
> > I'm running 12.5 on my laptop with utf8 as the native 
> character set. 
> > I'm tied up with another project right now, but if one of you can 
> > send me a test program I can compile and run it.
> > 
> > 
> > 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.




More information about the FreeTDS mailing list