Re: problem with unicode

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thus wrote tvin,

i can use 2bytes ,3byte...i don't have a problem
but the lenght of frédéric is len(frédéric) =10,
the lenght of frédéric should be 8 to insert correctly in sql database
. please help me jeorg

You're confusing bytes and characters. Frédéric has 10 characters, but it may have 10 or more bytes depending on the character encoding being used -- if you were using UTF-32, it would be a whopping 40 ;-)

Doesn't your database support the nvarchar type for Unicode characters?
--
Joerg Jooss
news-reply@xxxxxxxxxxxxx


.

Relevant Pages

  • Re: The need to get around the 4000 character limit in varchar2
    ... The SQL database has a few columns that are varchar columns, ... At this point I know of no way to migrate this data across to Oracle ... to change the column you are migrating from back to 4000 characters. ...
    (comp.databases.oracle.server)
  • unix username lenght
    ... I am able to create a unix username with 9 characters, but it complains lenght too long. ...
    (SunManagers)
  • Re: cant insert cyrillic or greek charachters into mssql db
    ... anmssqldatabase -field is nvarchar- i only see ??? ... incorrect characters. ... Showing the Characters in the Browser is no problem, ... Sounds like you need to be looking for help in an MS SQL database newsgroup. ...
    (comp.lang.php)
  • Help: 900 byte limit on stored procedure parameter?
    ... to my SQL database for remote review/testing. ... This config file is ... If I pass 901 characters I ...
    (comp.databases.ms-sqlserver)
  • Re: how to combine formulas to.........
    ... col A contains alphanumeric values of different lenght (<20 characters) made ... wheter the first part of a key of given lenght ... However, I copied column A, the properties, and pasted them into column ... results do reveal that when key length = 4 that the first key does not ...
    (microsoft.public.excel.worksheet.functions)