Using Kanji On Sybase.

Using Kanji On Sybase.

Post by Terran » Thu, 28 Feb 2002 19:18:57



Hi,

I need some pointers ( web sites most welcome ) on how I can create a
table to store Japanese Kanji characters.  I was told that it could be
done using varchar - but I could not find anything on this in
www.sybase.com.

Once created, how can I enter the data ?  Anyway with backslash
characters, etc ?  Tried but could not get it in.

On VB side which I am hoping to use to link to the Sybase, I have
found this article which seems to work fine :
  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q158870

but the danger from this seems to be that I will be manupulating my
own integers from Sybase into Kanji character equivalents.

Any help will be most welcome as I have always being using ASCII.

Many thanks !
Terrance

 
 
 

Using Kanji On Sybase.

Post by Anthony Mandi » Fri, 01 Mar 2002 21:00:15



> I need some pointers ( web sites most welcome ) on how I can create a
> table to store Japanese Kanji characters.  I was told that it could be
> done using varchar - but I could not find anything on this in
> www.sybase.com.

        You would use one of the character sets that support
        Kanji and the correct datatypes - nchar and nvarchar.
        If you use Unicode rather than deckanji or eucjis or
        whatever, its a little different. Unicode might be
        the better way to go in the long run. ASE 12.5 has
        special unichar and univarchar datatypes for UTF16.

Quote:> Once created, how can I enter the data ?  Anyway with backslash
> characters, etc ?  Tried but could not get it in.

        Depends on your front end. Sybase have or did have a
        Unicode Developer's KIT (UDK) that had an input app.

Quote:> On VB side which I am hoping to use to link to the Sybase, I have
> found this article which seems to work fine :
>   http://support.microsoft.com/default.aspx?scid=kb;EN-US;q158870

> but the danger from this seems to be that I will be manupulating my
> own integers from Sybase into Kanji character equivalents.

        You don't really need to do it the silly MS way.

-am     ? 2002

 
 
 

Using Kanji On Sybase.

Post by Terran » Sat, 02 Mar 2002 14:44:28


Thanks !

Cheers,
Terrance

 
 
 

1. SQL 6.5 (english) and Kanji/Other languages

Does anyone know if SQL Server 6.5 (not the J version) is capable of
storing Kanji characters?  If so, is it just a matter of adding the
Japanese code page to NT (4.0) and having SQL Server run under the ISO
character set?  Do I also have to add the language to SQL Server or is
that only applicable to the messaging system?

I know there is a separate J (japanese) version of SQL Server and I just
wanted to confirm that the english version can store data replicated
from that server.

Are there any other complications with storing French, German and Korean
characters in the English version of SQL Server?

2. Express 6.3

3. Full text indexing with Kanji?

4. Can you save login info from SQL7.0 for disaster recovery?

5. How to distinguish 1 and 1 that is japanese kanji

6. Creating an Excel-file with ADO (Bug???)

7. SQL 6.5 (english) and Kanji/Other languages

8. Bug-report about pgaccess for kanji-use

9. Kanji in JDBC-ODBC

10. Kanji conversion between databases w/ two different char sets

11. HELP: NLS support for Katakana-Kanji

12. Numeric values of Kanji characters