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?