How to save 'Migración Líneas 1&2' in SQL SERVER 2000

BalasahebK

Due to format like below, we are not able to save this information in SQL server 2000 Migración Líneas 1&2 Above information is saved in SQL SERVER 2000 as MigraciÃ³n sistema control AbellÃ³ Linde AlcalÃ¡ Can someone help me in this regard? Thanks

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Colin Angus Mackay

Are you using nvarchar columns or just varchar? I suspect you are using varchar and you would get it to work using nvarchar.

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

BalasahebK

Thanks for ur reply Yes I'm using Varchar in my table still I would like to know, is there any way to convert such word in some proper format? -- modified at 5:08 Thursday 24th August, 2006

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Mike Dimmick

Your source data appears to be UTF-8. Varchar columns in SQL Server 2000 are Windows-1252 if you're using the Modern_Spanish or Mexican_Trad_Spanish collations. Somewhere along the line, your UTF-8 data is being interpreted as Windows-1252. If you're using ADO or ADO.NET, all strings are internally Unicode (UTF-16) in the runtime, before being passed to the database, so you should check whatever process is passing the strings to ADO. For example, if reading from a file, you should check that the file is set to UTF-8 mode. Visual Basic 6.0 cannot do this - it always reads files using the thread's current code page. Bulk Insert also does not understand UTF-8. You will have to preprocess your file into something it does understand, either Windows-1252 or UTF-16.

Stability. What an interesting concept. -- Chris Maunder

BalasahebK

This is my original question Due to format like below, we are not able to save this information in SQL server 2000 1) Migración Líneas 1&2 Above information is saved in SQL SERVER 2000 as 2) MigraciÃ³n sistema control AbellÃ³ Linde AlcalÃ¡ Thanks for ur help for above message, still I have one question I would now like to convert the following statement in original format again means 3) MigraciÃ³n sistema control AbellÃ³ Linde AlcalÃ¡ (From database) into 4) Migración Líneas 1&2 (on browser) The below statement is saved properly in sql server 2000 Derivé Chloré PARC SUD but on browser, it is showing like below Deriv頃hlor驠PARC SUD -- modified at 7:11 Thursday 24th August, 2006 -- modified at 7:13 Thursday 24th August, 2006

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Colin Angus Mackay

BalasahebK wrote:

Yes I'm using Varchar in my table still I would like to know, is there any way to convert such word in some proper format?

So, did you try changing it to **_n_**varchar?

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog