Results 1 to 2 of 2

Thread: 5.5.1 - Server 2008 - MSSQL 2008 - Character Encoding Problem

  1. #1
    keats76 is offline Senior Member
    Join Date
    Dec 2008
    Posts
    21

    Default 5.5.1 - Server 2008 - MSSQL 2008 - Character Encoding Problem

    All,

    I was able to get 5.5.1 installed on my new 2008 box. It talks to my database (sql server 2008) if I use the native client for 2008 and the new ms php driver for mssql, but the character encoding seems off.

    Have you had any problems with multibyte support with the new Microsoft driver for PHP? I just finished an install on server 2008 with mssql 2008. If I install the native client for 2008 I can talk to the database, but if I use the native client for 2005 (which sugar reccommends) then it doesn't work. Anyway, if I try to save some Kanji (Japanese) characters on a test lead, they end up as ???? in the db.

    The problem may be twofold. Some of the fields in the database are "text" instead of ntext or nvchar(max). These fields will have issues with Japanese and other double byte charaters regardless of the driver used. However, the nvchar fields should handle it ok. If I enter in some text like: いちがつ into the SQL Server Management Console, then the nvarchar fields handle it fine and even populate to the webpage fine, but the second I update these fields, the data is corrupted in the DB (which leads me to think it's a driver issue).

    If I perform the same test of a text field (e.g. lead source description) then the data is always corrupted (management console or web).

    I'm curious, is there an installer that will run an mssql ddl install with nvarchar(max) fields instead of "text" or are they assuming we'll do that manually? Also, does the new mssql driver for php handle multi byte characters or do we have to hack together a FreeTDS install?

    Thanks!
    Mike

  2. #2
    keats76 is offline Senior Member
    Join Date
    Dec 2008
    Posts
    21

    Default Re: 5.5.1 - Server 2008 - MSSQL 2008 - Character Encoding Problem

    Took a while, but I figured it out ... go here if interested.

    Thanks,
    Mike

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dirty solution for 2008 R2, SQL 2008 and ISS 7.5
    By SteveFD in forum Installation and Upgrade Help
    Replies: 4
    Last Post: 2010-03-11, 03:32 PM
  2. Installation on Win 2008 SQL 2008 IIS 7.0
    By cmwatson in forum Installation and Upgrade Help
    Replies: 11
    Last Post: 2010-02-17, 04:14 PM
  3. Windows Server 2008 & Sugar Upgrades
    By thowden in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2008-12-23, 09:09 PM
  4. Replies: 1
    Last Post: 2008-07-09, 08:04 AM
  5. Character encoding in MSSQL
    By dricrm in forum Developer Help
    Replies: 2
    Last Post: 2008-03-19, 01:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •