Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase 12.5.1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Sybase 12.5.1
  • Date: Sat, 13 Dec 2003 09:20:14 -0000

Il sab, 2003-12-13 alle 09:47, James K. Lowden ha scritto:
> On 13 Dec 2003, Frediano Ziglio <freddyz77 AT tin.it> wrote:
>
> > 5- I still do not understand difference from varchar and nvarchar...
>
> Maybe I don't understand what you mean?
>
>
> Microsoft:
>
> varchar is a single-byte encoded string, encoded according to the
> server's installed character set. Maximum 8000 bytes, 8000 characters.
>
> nvarchar is a UCS-2 string. Maximum 8000 bytes, 4000 characters.
>
> Sybase:
>
> "The server types nchar and nvarchar are converted internally to char
> and
> varchar types, which correspond to the DB-Library type constant SYBCHAR."
>
> I guess sybase added "support" for nvarchar to be more compatible with
> Microsoft's T-SQL. Or perhaps it's a SQL92 type.
>

I don't understand that encoding of nvarchar on Sybase.. Are they
encoded in UTF-16, UCS-2 or what? They speak about "national character"
...

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page