Howdy, Stranger!

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

Categories

Unicode to ASCII table

TrackMaxTrackMax Member Posts: 2
Hi,

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?

Thanx,

Pieter
Sign In or Register to comment.