php-windows Digest 12 Oct 2009 19:40:05 -0000 Issue 3706
Topics (messages 29634 through 29635):
Re: How exactly do I get UTF-8 data into SQL Server on Windows via ODBC SQL
Native Client 10.0?
29634 by: Pierre Joye
Be penetrative with her
29635 by: Adanna Adlam
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
hi,
On Wed, Oct 7, 2009 at 10:36 AM, Richard Quadling
<rquadl...@googlemail.com> wrote:
> Hi.
>
> I'm trying to get data into an MS SQL Server 2005 database. The data
> is coming to me as UTF-8 encoded data.
Yes, pdo ODBC converts the results from UCS-2 to UTF-8. UCS-2 is what
sqlserver uses.
> The data is primarily European
> languages (so I've got a few accented characters), but I know I've got
> Korean, Vietnamese and some Japanese coming later.
>
> I'm using PHP 5.3.2-dev. The SQL Server is 2005 and the ODBC driver
> I'm using is SQL Native Client 10.0
> I've tried using ...
>
> $s_Recipient = mb_convert_encoding($s_Recipient, 'UCS-2', 'UTF-8');
Why do you want to go back to UCS-2?
Cheers,
--
Pierre
http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
--- Begin Message ---
Eliminate rod's flaccidity
http://axiomretl.com/
She'll be amazed with a sweet torment of your super-strong tool.
--- End Message ---
