Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Unanswered: how this select statment works please it is urgent?

    hey friends!
    pleaze help, i am using sql server 2000.i have tried to fix my problem for more than five weeks just to solve for one problem and just still now it is unsolved, opps my due date is almost approaching, i don't know what to do more than what i did, i have search through the net, but still i did not get the correct answer to my problem, friends please just forward your answer to me, it may be best answer to my question .
    create table mytable( english varchar(120), tigrigna Nvarchar(120))
    insert into mytable values('peace',N'sälam')
    insert into mytable values('kiss',N'samä ')
    insert into mytable values('to kiss each other',N'täsasamä ')
    then
    select * from mytable where english='peace'; this works fine
    but
    select * from mytable where tigrigna=N'sälam'; this doesnot work;
    select * from mytable where tigrigna='sälam'; this also doesnot work,
    so what should i do to select this unicode select statement?

    tigrigna is one of the spoken language in east africa(ethiopia).
    Hopefully, i have joined this forum today, and just looking for your reply

    I am Looking for your reply !

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Nebrom
    This code:
    Code:
     
    use tempdb 
    go
    IF EXISTS (SELECT NULL FROM sys.tables WHERE name = N'mytable') BEGIN
    DROP TABLE dbo.mytable
    END
     
    create table mytable( english varchar(20), tigrigna Nvarchar(20))
    insert into mytable values('peace',N'sälam')
    insert into mytable values('kiss',N'samä ')
    insert into mytable values('to kiss each other',N'täsasamä ')
     
    SET nocount on
     
    select * from mytable where english='peace'
    select * from mytable where tigrigna=N'sälam'
    select * from mytable where tigrigna='sälam'
     
    IF EXISTS (SELECT NULL FROM sys.tables WHERE name = N'mytable') BEGIN
    DROP TABLE dbo.mytable
    END
    elicits:
    Code:
     
    english tigrigna
    -------------------- --------------------
    peace sälam
     
    english tigrigna
    -------------------- --------------------
    peace sälam
     
    english tigrigna
    -------------------- --------------------
    peace sälam
    I have little experience with unicode data so I don't really no what the problem might be but it looks likely that it is a database\ server setting. Collation perhaps?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •