Solved

Multi-language Character Sets (PHP & MySql)

Posted on 2003-11-30
1
876 Views
Last Modified: 2013-12-12
Hi,

I've read Mysql 4.1 to see how to set the charater set values at database, table and even column level, when working with multi language characters.

Very simply, can PHP handle passing over different character sets to MySql e.g. insert arabic characters, then insert ISO 8859-1 (western) characters.

Best wishes
sabi97
0
Comment
Question by:sabi97
1 Comment
 
LVL 1

Accepted Solution

by:
drew22 earned 125 total points
ID: 9845659
have you checked out php's utf8_encode() and utf8-decode()?

utf8_encode() -- encodes an ISO-8859-1 string to UTF-8 unicode
http://us3.php.net/manual/en/function.utf8-encode.php

utf8-decode() -- converts a string with ISO-8859-1 characters encoded with UTF-8 to single-byte ISO-8859-1.
http://us3.php.net/manual/en/function.utf8-decode.php

aw
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
hosting images 4 31
PHP-Client-Registration-Login article and  saving last last login 6 31
php checkbox validation 5 27
Logic behind "best rated" calculation 11 23
This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question