Inputting Greek in a simple input form to SQL DB

Hello there experts,

This must be a rather simple question, but I need your help:

I have an intranet website that collects different languages such as English, Portugese, Italian, French, Japanese etc. The first languages I all handle with Unicode, the last with SHIFT_JIS.

However, now that we want to add Greek to it, I'm seeing problems not with the display side of things, but with getting form input to our SQL database. Let me explain:

Whenever I type Greek data using the built-in Windows Language Bar (http://support.microsoft.com/default.aspx?scid=kb;en-us;306993&sd=tech) DIRECTLY into SQL, the data is saved normally and displays fine when fetched in ASP. However, when I do the same thing and type the data in a web form first (displays fine) the data doesn't get saved in SQL proper.

Strangest thing is that our web applications are working fine for all those other languages...

This is the code I used for setting our web apps to Unicode:
strCharset = "UTF-8"
Response.Charset = "utf-8"
Session.Codepage = 65001
.......
<META http-equiv=Content-Type content="text/html; charset=<%= strCharset %>">

So this is what I did for Greek (since as with Japanese input, Unicode didn't work):
strCharset = "iso-8859-7"
Response.Charset = "iso-8859-7"
Session.Codepage = 1253
........
<META http-equiv=Content-Type content="text/html; charset=<%= strCharset %>">

Am I using the wrong charset or codepage here? Please advise!

Thanks,
Victor
vpikulaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vpikulaAuthor Commented:
Anyone??

Victor
0
selohCommented:
I believe the problem lies in http, the form sends the data to the next page as ascii which doesn't support the greek alphabet.
My best bet is to create a javascript that converts the greek letters into ascii before sending them to the next page!

http://www.alanwood.net/unicode/greek.html
0
vpikulaAuthor Commented:
That's a good point -- So I need to convert the form data to html codes first? Do you have a good function for that? (seems quite manual...)
0
selohCommented:
It would be something like this in ASP:
<%
  Function translate(string)
    convertor = "&#945;@&alpha;|&#946;@&beta;|.....etc"
    convertor = split(convertor, "|")

    loops = UBound(split(convertor, "|"))

    FOR i=0 TO loops
      loopy = split(convertor(i), "@")
      string = replace(string, loopy(0), loopy(1))
    NEXT
  End Function
%>
This function has to be preformed before you send it though!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vpikulaAuthor Commented:
Hmmm yes that will do for converting it from Unicode to HTML codes I guess -- will give that a go and award you the points nonetheless, closing this old topic.

Many thanks,
Victor
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.