| Author |
 Topic  |
|
David K
Junior Member
494 Posts |
 Posted - 07 November 2002 : 19:24:17
|
| It's not the problem, it works but doesn't change anything, it's a db problem< |
 |
|
|
David K
Junior Member
494 Posts |
Posted - 19 November 2002 : 08:14:29
|
| Probably db driver! problem< |
|
|
|
David K
Junior Member
494 Posts |
Posted - 18 December 2002 : 12:46:57
|
OK, sorry for bumping this after a long time, but the problem expands!
I can't use a Hebrew codepage on a forgien computer (because Hebrew support is an optional component in Win 2K)
My host agrees to install it for me, but I want it to work on EVERY server around. Is there another option besides going Unicode?
BTW, it doesn't work properly when I use my own MSSQL2000 server as well< |
Edited by - David K on 18 December 2002 12:49:32 |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 18 December 2002 : 16:38:02
|
quote:
I want it to work on EVERY server around
I don't think there is an option for that.
You can use Access 200x with newer Jet drivers and have Unicode.
quote:
BTW, it doesn't work properly when I use my own MSSQL2000 server as well
What do you mean by "doesn't work properly"? Can you be more specific about the problem and server setup(s)?
< |
 Stop the WAR! |
|
|
|
David K
Junior Member
494 Posts |
Posted - 18 December 2002 : 17:10:55
|
SQL server - my own server, supports Hebrew.
Web server - Kiwibloke.com (doesn't support Hebrew)
session.LCID - ccannot be changed to hebrew
error- ???? in DB and in site< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 18 December 2002 : 20:01:17
|
| Did you try the same setup with Access 2k database on web server and using correct HTML encoding setting (without session.LCID)?< |
Stop the WAR! |
|
|
|
David K
Junior Member
494 Posts |
Posted - 18 December 2002 : 21:37:02
|
yes, it works, but the DB has only accented characters. although the forum works properly, it's a major broblem for backups since I can't understand\edit the DB contents. so if I move the DB to a server that does support Heberw, I'll lose all my data!
BTW, it's always with correct HTML charset settings< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 18 December 2002 : 22:36:17
|
I understand. This is the same problem I lived when I moved to Access 2000 from Access 97 (described on the link I posted above).
I never tried it, but perhaps it can be solved by a "global find replace" script, if you can identify the character sequences (i.e. numeric counterparts). VBS cannot work on UTF-8 data directly but there are methods to make them UTF-16 and work on these...
That will be a very important utility (if you want to give a try  )...
< |
Stop the WAR! |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 18 December 2002 : 22:41:02
|
One more Q:
Is the utf-8 not a solution for you? I think every web server (w2k/XP) will support it. Also Access 2000, Access XP, MS-SQL 7, MS-SQL 2000 support them except some minor issues, mostly related to far-eastern languages.
< |
Stop the WAR! |
|
|
|
David K
Junior Member
494 Posts |
Posted - 19 December 2002 : 04:55:15
|
| I don't want to use UTF-8 because of email, I believe it would represent a problem< |
|
|
|
David K
Junior Member
494 Posts |
Posted - 20 December 2002 : 17:55:57
|
so, does anyone have an idea on what to do?
BTW, if I use utf-8, could EVERYBODY visit the site?< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 20 December 2002 : 18:16:23
|
Yes, but seahorse was mentioning about an issue where in some cases the browser does not select the encoding properly... I also saw that on some sites (like this one) where does not use an charset statement in the header. It must be because of the "auto-select" algorithm in the browser...
I think, you can use utf-8 for the website and another formatting for the e-mails. To accomplish this, you can just extract e-mail related text to another file and save it with enother encoding. Why don't you give a try to that?
Perhaps it will be a good idea to have e-mail related text in another file...
< |
Stop the WAR! |
|
|
|
David K
Junior Member
494 Posts |
Posted - 20 December 2002 : 18:41:01
|
| it's too much changes to the base code, I want people to have a forum that is compatible with the original, yet gives the ultimate Hebrew support possible, and I think that I've reached it.< |
|
|
|
Topic |
|
Forum Locked
