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
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]
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.
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
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
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 mes
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 ma
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
--
- 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:
> > H
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 wi
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*
SQL
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 :
>
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 TABLE `city` ADD `name_heb` ENUM( ,
'סלאוויטא',
'ניקאלאיעוו',
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
>
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 inse
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 sort
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 that didn't seem to work. Could anyone point me in the rig
17 matches
Mail list logo
