Post reply

Russian characters encoding problem

  • June 7, 2010 at 6:32 am

    #219741

    Hi i use an application getting data from Russian site which gets saved in database in Russian characters.For example following names are saved in as

    Àíäðåé ,Ãóëüøàò , Åêàòåðèíà , Ðèììà , Àëåêñåé , Äèàíà , Ðàèñà

    which should be saved as

    Aiaoae , Aoeuoao, aeoaoadeia, Deiia , Aeaenae , Aeaia , Daena

    I need to convert them into english characters by decoding them,

    Any one has idea how it can be done,

  • June 7, 2010 at 8:06 am

    #1177089

    Try

    SELECT CAST('Àíäðåé ,Ãóëüøàò , Åêàòåðèíà , Ðèììà , Àëåêñåé , Äèàíà , Ðàèñà' as varchar(8000)) COLLATE Chinese_Traditional_Stroke_Order_100_CS_AS_KS_WS

    I happen to be working in a similar area and I think this works because you can't represent these characters in a chinese collation when in varchar so SQL converts them.

    I CAN'T GUARANTEE IT ALWAYS WORKS.

    There may well be better solutions too.

    Tim

    .

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply