Re: Unicode and long data type

Ah, a Long is an integer type. The SQL Server equivalent is a BigInt that
can store up to 8 bytes (64 bits) of data. It can store any number within
its range (about 2^63). A Unicode type is a character type (16
bits/character). There is no way to store a Unicode value (more than 4 16bit
characters) into a Long (big int). You can convert a few characters into
their hex equivalent and store that...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

<Tom_Foran@xxxxxxxxxxx> wrote in message
news:1169426019.880612.284570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an application where a limited amount of Unicode data is being
inserted into a long data type field by an AIX program. I have written
a dotnet program that copies the data from one domain to another with
parameterized data. Everything works except for the Unicode data in the
long field.

My Characterset info is:

NLS_CHARACTERSET US7ASCII
NLS_NCHAR_CHARACTERSET AL16UTF16

Regional Settings are

English (United States)
A basic default U.S. installation of Windows.

I do not have much control over the database.

I have read that long data types do not support Unicode.

Is there anyway I can insert Unicode data into a long data type from a
dotnet program?



.

Relevant Pages

  • Re: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Access 2000 - Realtime Development - Should i stick with Access97
    ... if I needed to start using SQL Server to store Tables of an Access 97 front ... would this force the need to upgrade. ... > is because you have support clients who are using later versions. ...
    (microsoft.public.access.modulesdaovba)
  • Re: PDFs in blobs and SQL2005
    ... FOr this to work you need to store the date in your serach field. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... Also the PDFs will be in blobs internally. ...
    (microsoft.public.sqlserver.fulltext)
  • "Linked Table" from a .txt file in SQL Server?
    ... OKay, I'm really, really good with MS Access, but am just getting up to speed ... on SQL Server. ... Is there a SQL Server equivalent of linking a ...
    (microsoft.public.sqlserver.odbc)