Re: [GENERAL] convert string function and built-in conversions

2003-10-19 Thread Stephan Szabo
On Sun, 19 Oct 2003, culley harrelson wrote: > It is one of the extended characters in iso-8859-1. This data was taken > from a text field in a SQL_ASCII database. Basically what I am trying to > do is migrate data from a SQL_ASCII database to a UNICODE database by > running all the data through

Re: [GENERAL] convert string function and built-in conversions

2003-10-19 Thread culley harrelson
It is one of the extended characters in iso-8859-1. This data was taken from a text field in a SQL_ASCII database. Basically what I am trying to do is migrate data from a SQL_ASCII database to a UNICODE database by running all the data through an external script that does something like: select

Re: [GENERAL] convert string function and built-in conversions

2003-10-19 Thread Stephan Szabo
On Sun, 19 Oct 2003, culley harrelson wrote: > It seems to me that these values should be the same: > > select 'lydia eugenia treviño', convert('lydia eugenia treviño' using > ascii_to_utf_8); > > but they seem to be different. What am I missing? I don't think the marked n is a valid ascii chara

[GENERAL] convert string function and built-in conversions

2003-10-18 Thread culley harrelson
It seems to me that these values should be the same: select 'lydia eugenia treviño', convert('lydia eugenia treviño' using ascii_to_utf_8); but they seem to be different. What am I missing? culley ---(end of broadcast)--- TIP 8: explain analyze i