Unicode to ASCII table


At the moment I got stuck in the following problem. I have two tables with a text library. One is in unicode with a column type nvarchar and the other table is using varchar. I want to copy the Unicode texts into the other table by converting the texts to ASCII characters based on a font codepage. Later on in the application that uses the ASCII set I will use that code page to show the texts as they were in unicode.
At the moment I think of using a text file and use a code page conversion on that. However I would prefer to do it without files, via the SQL query analyzer.

Does anyone have any suggestions how to do this?


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!