Google Community Chat
 
database conversion

You're visiting Google Community as a guest.
In order to post, you'll need to register and log in.



(If you were registered and logged in, these advertisements wouldn't be here)
Post new topic   Reply to topic    Google Community Forum Index // Web Design, Coding & Programming Forum
   
Author Message
sipoor
Noogle
Noogle


Joined: 03 Dec 2005

172.05 GC$

Items

PostPosted: Sat Dec 03, 2005 6:15 pm    Post subject: database conversion Reply with quote
Hello people,
I'm using an access database for my website which stores iso-8859-8-i (Hebrew) data.
In order for adsense to show ads on my site I have to convert my pages from iso-8859-8-i to UTF-8.
I'm using ASP as my servers' script language.
Is there a way to convert the database into utf-8?
If not, can I at least convert the data after retrieving it from the database before outputting it to a utf-8 page?

Thanks... I need help Crying or Very sad
Back to top
View user's profile Send private message
killerpants
Noogle
Noogle


Joined: 24 Jul 2005

730.00 GC$

Items

PostPosted: Sun Jan 15, 2006 9:06 pm    Post subject: i hope this works Reply with quote
so i just did a quick google search on how to do this Smile
idk if this works, but it sounds reasonable:
http://vietunicode.sourceforge.net/howto/convertaccessdb.html
Back to top
View user's profile Send private message
sipoor
Noogle
Noogle


Joined: 03 Dec 2005

172.05 GC$

Items

PostPosted: Tue Jan 17, 2006 2:39 pm    Post subject: Thanks, it worked eventually Reply with quote
First, how did you manage to find the link?
I looked all over and couldn't find something as helpful as the link you found.
Thank you very much.

The instructions in the link did not work as described.
I managed to convert the database eventually but only after encoding in "user defined encoding" and creating a new table.
Then I imported the data to the new table and fixed some errors. After that I copied the data into the original database.
Finally I saved all my asp pages in UTF-8 and added the session.codepage=65001 code.

Thanks again.
Back to top
View user's profile Send private message
darrenstraight
Site Admin & Platinum Member
Site Admin & Platinum Member


Joined: 25 Jul 2004
Location: England
173385.09 GC$

Items

PostPosted: Tue Jan 17, 2006 5:10 pm    Post subject: Reply with quote
Glad to see you got it converted *put's away magical converting tool* Smile
_________________
My Blog | Microsoft Discussion
Back to top
View user's profile Send private message Visit poster's website
Sponsored Links
Posted: 4 Dec 2008 12:38 am    Post subject: Advertisements
Back to top
Post new topic   Reply to topic    Google Community Forum Index // Web Design, Coding & Programming Forum All times are GMT - 8 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Host your free forums with Invision Plus.net forum web hosting with your own subdomain.

alexisBlue v1.2 // Theme Created By: Andrew Charron // Icons in Part By: Travis Carden

© 2005-2006 Google Community

Powered by phpBB

Privacy Policy | Contact Us

Powered by Google Search blog

This website is not affiliated in any way with Google, Inc.
Google™ is a registered trademark of Google, Inc.