While this is not directly linux related it is FOSS related.
I have a MySQL 5 database that has fields with Hebrew values. The
fields are defined as varchar with a hebrew_general_ci collation. I
have a PHP page that takes values specified in a form field and runs a
query against the table.
You've chosen a ISO-8859-8 (logical or visual play no role here) encoding
for the MySQL tables. Do you know which encoding your PHP pages accept the
form data in? (And why for heaven's sake somebody developing an app in 2007
doesn't use UTF-8 everywhere?)
On 5/10/07, David Suna [EMAIL PROTECTED]
Your input and stored data need to agree in character set. Make sure
either that you are displaying the page to the user in a hebrew
character set (so that input will be sent back in same charset) or as
was already suggested, switch everything over to utf8.
You can do this either by using
On Thu, Jan 29, 2004 at 02:40:40PM +0200, Aaron wrote:
Hi all,
I am creating a mysql database which needs to have fields in hebrew and
other in english. This means that the text will be in hebrew.
when I type hebrew in a field I get an error and I see this:
*Error*
SQL-query :
ALTER
Yedidyah Bar-David wrote:
On Thu, Jan 29, 2004 at 02:40:40PM +0200, Aaron wrote:
Hi all,
I am creating a mysql database which needs to have fields in hebrew and
other in english. This means that the text will be in hebrew.
when I type hebrew in a field I get an error and I see this:
*Error*
Alon Weinstein wrote:
do man mysqld and look for the charset settings. The mysql manual also
addresses this issues. I think that in mysql 4.x you can also define
charset per table, but I'm not sure.
According to the MySQL roadmap presented at LCA2004, MySQL 4.0 adds
support for
UTF-8 and 4.1
--
- Original Message -
From: Yedidyah Bar-David [EMAIL PROTECTED]
To: Aaron [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 3:09 PM
Subject: Re: mysql hebrew
On Thu, Jan 29, 2004 at 02:40:40PM +0200, Aaron wrote:
Hi all,
I am creating a mysql database which needs to have
Once in phpMyAdmin, set the encoding to one of the Hebrew encodings, and
then defining the table.
On Thu, 29 Jan 2004, Alon Weinstein wrote:
Yedidyah Bar-David wrote:
On Thu, Jan 29, 2004 at 02:40:40PM +0200, Aaron wrote:
Hi all,
I am creating a mysql database which needs to have
I'll give a look,
thanks
aa
do man mysqld and look for the charset settings. The mysql manual also
addresses this issues. I think that in mysql 4.x you can also define
charset per table, but I'm not sure.
=
To unsubscribe, send
Actually when I enter data I see the hebrew the error only happens when
I save.
I gather I have to set something in database to use hebrew.
Aaron
=
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word unsubscribe in the
Hi all,
Here is what I found in the msql docs:
You can change the character set with the |--default-character-set|
option when you start the server. The character sets available depend on
the |--with-charset=charset| and |--with-extra-charsets= list-of-charset
| complex | all | none| options to
When typing in hebrew, you should ALWAYS use hebrew encoding.
I suggest windows-1255.
Oleg.
On Thu, 29 Jan 2004 14:40:40 +0200, Aaron [EMAIL PROTECTED] said:
Hi all,
I am creating a mysql database which needs to have fields in hebrew and
other in english. This means that the text will be in
Hi,
As far as I remember you should be able to insert hebrew characters by
default (explain what exactly doesn't work). If you compile it by
yourself, you probably want to use some --with-charset=hebrew or something
similar (run ./configure --help..), which adds some hebrew support, such
as
As Oren wrote, you have to compile the hebrew charset (either
dynamically or statically into mysql).
Another way of making hebrew sorting/grouping work is by using VARCHAR
BINARY instead of VARCHAR. I never tested it, though.
Oren Held wrote:
Hi,
As far as I remember you should be able to
On Saturday 21 December 2002 00:05, Ben Hornedo wrote:
All:
A quick question (hopefully with a quick answer). I have MySQL setup on a
machine and I'm trying to configure it so I can store Hebrew text (names,
addresses, etc.). I tried using set-character-set=hebrew in the my.cnf file
but
15 matches
Mail list logo