Hebrew and ??? 4.1.7nt and Access
Posted by: Alon Solell
Date: July 18, 2005 06:14PM
Date: July 18, 2005 06:14PM
Hello All,.
I'm semi-confused about this:
I can view in phpMyAdmin the data fine. Hebrew is showing up with no problems.
I use the MySQL-Front and I see Hebrew with no problem.
However, when I try to retireve the data via an ASP with ODBC connection, it
brings question marks ????? ????? instead of hebrew text.
This code works fine when it is connected to an Access.mdb file.
We are in the process of migrating from ms-access.mdb into mysql.
So importing into the mysql server worked fine,. and I can view the data with
phpMyAdmin with no problem.
My only problem is when trying to retrieve the same data via the same code that
worked earlier with the access.mdb file.
Any pointers? suggestions?
mysql version 4.1.7nt
Here is a snapshot of a code that I'm using to retrieve the data from my
database.
It is pulling up with just question marks that looks like: ????? ?????
<%
session.codepage = 1255
DBType = "mysql"
'MySQL ODBC Connection String
datasourcename = "DRIVER={MySQL ODBC 3.51 Driver};
SERVER=localhost;DATABASE=alons_test1; USER=alon; PASSWORD=123; OPTION=3;"
cursortype = 3
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open datasourcename
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rs_main = Server.CreateObject("ADODB.Recordset")
Sub ExecuteSQL(QueryText, cursortype, recordsetname)
'-------------------------------------------
'THE TWO LINES BELOW ARE FOR DEBUGGING
'UNCOMMENT THEM IF QUERIES ARE FAILING
'-------------------------------------------
Response.Write(QueryText&"<br><br>")
'On Error Resume Next
cmdTemp.CommandText = QueryText
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
If DBType = "mysql" Then recordsetname.CursorLocation = 3
recordsetname.Open cmdTemp, , 1, cursortype
End Sub
theQuery = "SELECT HEADER_homepage_heading FROM tblSystemHeaders"
Call ExecuteSQL(theQuery, CursorType, RS_Main)
'-----------------------------------------------------------
'-----------------------------------------------------------
if not RS_Main.eof then
CAT_heading = rs_main("HEADER_homepage_heading")
end if
rs_main.close
%>
<html>
<title>Hello Alon's World</title>
<body>
<TABLE ALIGN=CENTER BORDER=0 CELLSPACING=10 CELLPADDING=0
WIDTH=100%CLASS="mednormal">
<TR>
<TD>
<%=CAT_heading%><BR>
</TD>
</TABLE>
</body>
</html>
I've also included the definition of the table:
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 17, 2005 at 03:18 AM
-- Server version: 4.1.7
-- PHP Version: 4.3.10
--
-- Database: `alon_test1`
--
-- --------------------------------------------------------
--
-- Table structure for table `tblsystemheaders`
--
CREATE TABLE `tblsystemheaders` (
`HEADER_id` int(10) NOT NULL auto_increment,
`HEADER_regdate` datetime default NULL,
`HEADER_newsbox_heading` varchar(200) default NULL,
`HEADER_newsbox_text` longtext,
`HEADER_homepage_heading` varchar(200) default NULL,
`HEADER_homepage_text` longtext,
`HEADER_faq_heading` varchar(200) default NULL,
`HEADER_faq_text` longtext,
`HEADER_contactus_heading` varchar(200) default NULL,
`HEADER_contactus_text` longtext,
PRIMARY KEY (`HEADER_id`),
UNIQUE KEY `infopage_id` (`HEADER_id`)
) ENGINE=InnoDB DEFAULT CHARSET=hebrew AUTO_INCREMENT=2 ;
NOTE: English letters pull up fine with no problems at all.
It is specifically a problem with Hebrew chars.
my.ini has the following in it:
[MySQLD]
port=3306
basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data
default-character-set=hebrew
default-collation=hebrew_general_ci
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=1
[client]
port=3306
Does this help to analyze the problem?
Thanks,
-Alon.
alon@wsco.com
I'm semi-confused about this:
I can view in phpMyAdmin the data fine. Hebrew is showing up with no problems.
I use the MySQL-Front and I see Hebrew with no problem.
However, when I try to retireve the data via an ASP with ODBC connection, it
brings question marks ????? ????? instead of hebrew text.
This code works fine when it is connected to an Access.mdb file.
We are in the process of migrating from ms-access.mdb into mysql.
So importing into the mysql server worked fine,. and I can view the data with
phpMyAdmin with no problem.
My only problem is when trying to retrieve the same data via the same code that
worked earlier with the access.mdb file.
Any pointers? suggestions?
mysql version 4.1.7nt
Here is a snapshot of a code that I'm using to retrieve the data from my
database.
It is pulling up with just question marks that looks like: ????? ?????
<%
session.codepage = 1255
DBType = "mysql"
'MySQL ODBC Connection String
datasourcename = "DRIVER={MySQL ODBC 3.51 Driver};
SERVER=localhost;DATABASE=alons_test1; USER=alon; PASSWORD=123; OPTION=3;"
cursortype = 3
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open datasourcename
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rs_main = Server.CreateObject("ADODB.Recordset")
Sub ExecuteSQL(QueryText, cursortype, recordsetname)
'-------------------------------------------
'THE TWO LINES BELOW ARE FOR DEBUGGING
'UNCOMMENT THEM IF QUERIES ARE FAILING
'-------------------------------------------
Response.Write(QueryText&"<br><br>")
'On Error Resume Next
cmdTemp.CommandText = QueryText
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
If DBType = "mysql" Then recordsetname.CursorLocation = 3
recordsetname.Open cmdTemp, , 1, cursortype
End Sub
theQuery = "SELECT HEADER_homepage_heading FROM tblSystemHeaders"
Call ExecuteSQL(theQuery, CursorType, RS_Main)
'-----------------------------------------------------------
'-----------------------------------------------------------
if not RS_Main.eof then
CAT_heading = rs_main("HEADER_homepage_heading")
end if
rs_main.close
%>
<html>
<title>Hello Alon's World</title>
<body>
<TABLE ALIGN=CENTER BORDER=0 CELLSPACING=10 CELLPADDING=0
WIDTH=100%CLASS="mednormal">
<TR>
<TD>
<%=CAT_heading%><BR>
</TD>
</TABLE>
</body>
</html>
I've also included the definition of the table:
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 17, 2005 at 03:18 AM
-- Server version: 4.1.7
-- PHP Version: 4.3.10
--
-- Database: `alon_test1`
--
-- --------------------------------------------------------
--
-- Table structure for table `tblsystemheaders`
--
CREATE TABLE `tblsystemheaders` (
`HEADER_id` int(10) NOT NULL auto_increment,
`HEADER_regdate` datetime default NULL,
`HEADER_newsbox_heading` varchar(200) default NULL,
`HEADER_newsbox_text` longtext,
`HEADER_homepage_heading` varchar(200) default NULL,
`HEADER_homepage_text` longtext,
`HEADER_faq_heading` varchar(200) default NULL,
`HEADER_faq_text` longtext,
`HEADER_contactus_heading` varchar(200) default NULL,
`HEADER_contactus_text` longtext,
PRIMARY KEY (`HEADER_id`),
UNIQUE KEY `infopage_id` (`HEADER_id`)
) ENGINE=InnoDB DEFAULT CHARSET=hebrew AUTO_INCREMENT=2 ;
NOTE: English letters pull up fine with no problems at all.
It is specifically a problem with Hebrew chars.
my.ini has the following in it:
[MySQLD]
port=3306
basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data
default-character-set=hebrew
default-collation=hebrew_general_ci
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=1
[client]
port=3306
Does this help to analyze the problem?
Thanks,
-Alon.
alon@wsco.com
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.