ASP character translation
This is an interesting one...
I have a web application built in ASP that accepts user input, then ends up putting the information into a database.
Yeah, no big deal.
The database has some character fields where the data type is single-byte character. Now, this application is used world wide. This is the fun part. Why? A client in Japan that uses a version of this app (obviously each country has a slightly modified version of this application running on their intranet, which then puts data into our database). The Japanese characters are unicode/double-byte characters. Previously, when the app was passing the data through informix, we could just translate the doubles to singles and put it in the database. Well, the latest update on informix stops this from happening, as it's also a security hole (or something, I don't really deal with that part of it, I was just told it doesn't do it anymore). Currently, updating the database is out of the question. Don't ask, I can't give you the answer.
So, my question is this: Is there a way in ASP that I can convert the double-byte to single-byte before passing them on from the ASP app to the next layer in the system? I have some ideas, but I don't want to create a box for anyone.
Also, if I find an answer and anyone else is curious, I'll be glad to post the info here if you so desire.
I have a web application built in ASP that accepts user input, then ends up putting the information into a database.
Yeah, no big deal.
The database has some character fields where the data type is single-byte character. Now, this application is used world wide. This is the fun part. Why? A client in Japan that uses a version of this app (obviously each country has a slightly modified version of this application running on their intranet, which then puts data into our database). The Japanese characters are unicode/double-byte characters. Previously, when the app was passing the data through informix, we could just translate the doubles to singles and put it in the database. Well, the latest update on informix stops this from happening, as it's also a security hole (or something, I don't really deal with that part of it, I was just told it doesn't do it anymore). Currently, updating the database is out of the question. Don't ask, I can't give you the answer.
So, my question is this: Is there a way in ASP that I can convert the double-byte to single-byte before passing them on from the ASP app to the next layer in the system? I have some ideas, but I don't want to create a box for anyone.
Also, if I find an answer and anyone else is curious, I'll be glad to post the info here if you so desire.
