character_set_xxx variables to Hebrew
I then looked at the values, show variables like '%char%'; and all was fine.
However if I then exit MySQL Control centre and then go back to it my
character_set_xxx variables are all back at their defaults ?
I'm assuming this is a permissions type
Greg
I use MySQL Control centre to access my dbase and I have set
My character_set_xxx variables to Hebrew
I then looked at the values, show variables like '%char%'; and all was fine.
However if I then exit MySQL Control centre and then go back to it my
character_set_xxx variables are all
- I
assume they will be ok ?
John B
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 07 March 2005 21:12
To: mysql@lists.mysql.com
Subject: Re: Hebrew
Hello.
Put all your character_set_xxx variables to hebrew. See:
http
Hello.
Put all your character_set_xxx variables to hebrew. See:
http://dev.mysql.com/doc/mysql/en/charset-connection.html
John Berman [EMAIL PROTECTED] wrote:
How's this
+--+---+
| Variable_name| Value
Thanks will do this.
In the same dBase there a lots of tables were the data is in English - I
assume they will be ok ?
John B
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 07 March 2005 21:12
To: mysql@lists.mysql.com
Subject: Re: Hebrew
Hello.
Put all your
4.1
Though I had it cracked ?
I created a new table and set the Charset to Hebrew and the field =
=A0Collation
to hebrew_general_ci=A0
I then uploaded data to the database using MS Acess (with an ODBC
connection)
In MSAccess on my PC the Hebrew comes through fine
|
| character_set_connection | latin1|
| character_set_database | hebrew|
| character_set_results| latin1|
| character_set_server | latin1|
| character_set_system | utf8
Using 4.1
Though I had it cracked ?
I created a new table and set the Charset to Hebrew and the field Collation
to hebrew_general_ci
I then uploaded data to the database using MS Acess (with an ODBC
connection)
In MSAccess on my PC the Hebrew comes through fine.
However when I open
Hi
Our host runs MySQL 4.1 and we have a number of datasets with Genealogical
data in them. When a grave stone is translated to English often the meaning
is lost or the translation is simply not accurate. So how easy or difficult
would it be to actually hold the text in Hebrew purely
the meaning
is lost or the translation is simply not accurate. So how easy or difficult
would it be to actually hold the text in Hebrew purely for display purposes
(don?t think we need to search it etc) within the data set.
Thoughts appreciated.John Berman [EMAIL PROTECTED] wrote:
[snip
Noamn [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I asked about a week ago how to get mySQL to index correctly in Hebrew,
and
the best answer that I received was to define a my.cnf file as follows
[mysqld]
set-variable = default-character-set = hebrew
I created the file /etc
I asked about a week ago how to get mySQL to index correctly in Hebrew, and
the best answer that I received was to define a my.cnf file as follows
[mysqld]
set-variable = default-character-set = hebrew
I created the file /etc/my.cnf using the root account, stopped the mysql
daemon then restarted
... default-character-set=hebrew should not
have any spaces.
[mysqld]
set-variable = default-character-set=hebrew
You can also try invoking this option on the command line when starting the server
like this:
/usr/local/mysql/bin/mysqld_safe --default-character-set=hebrew
with 3.23.xx I think
I don't think you can use alter table to change character sets in version 3.23.51.
You must do it at the server level. Try starting mysql with this command line option:
--default-character-set=hebrew
Hope this helps.
Jeremy
I have run the 'show variables' query on my database and see that the
default character set is latin-1, and 'character_sets' includes 'hebrew'.
So I tried the following command
alter database presale default character set hebrew;
only to be awarded with a 'you have an error in your SQL syntax
Does anyone have any experience of working with mySQL in Hebrew?
The front end to my database is written in Delphi/Windows; it transmits
Hebrew characters and displays Hebrew characters. The backend is in
mySQL/Linux, and what was Hebrew appears in English characters. The only
problem which I
Hytham Shehab wrote:
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check
Hytham,
Thursday, July 25, 2002, 12:54:22 AM, you wrote:
HS am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
HS characters of language such as hebrew/arabic?
MySQL returns char strings as they were inserted. For correct sorting
you can set up hebrew character set
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check:
http
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check:
http://www.mysql.com
I try to compile mysql with hebrew and did not success.
I compile it on solaris 5.6.
When I configure it with:
./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory
--with-extra-charsets=complex --with-charset=hebrew --enable-assembler
or When I configure it with:
./configure
Afgin,
Tuesday, April 23, 2002, 1:14:17 PM, you wrote:
AS I try to compile mysql with hebrew and did not success.
AS I compile it on solaris 5.6.
AS When I configure it with:
AS ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory
AS --with-extra-charsets=complex --with-charset
23 matches
Mail list logo