php/pdo sql server tie i18n issues

in the web-app php5.2.6 + pdo bond sql server 2005 database store russian texts.

database comparison cyrillic_general_ci_as, list comparison cyrillic_general_ci_as, buttress form nvarchar(max).

we attempted joining database controlling twin following schemes, both causing opposite problems.

1. pdo mssql:

   
   
   

   $dbh = new pdo ('mssql:host='.$mssql_server.';dbname='.$mssql_db, $mssql_login, $mssql_pwd);
   

   
   
   

   in box outcome rudimentary query that:

   
   
   

   select field1 tbl1 where id=1
   

   
   
   

   shows field1 information truncated 255 bytes.




2. pdo odbc:

   
   
   

   $dbh = new pdo ('odbc:dsn=mydsn;uid='.$mssql_login.';pwd='.$mssql_pwd);
   

   
   
   

   in box outcome same query shows full truncated information nonetheless doubt outlines instead russian symbols.

---

notes:

• in sql supervision studio information truncated russian black displayed morally well.


• we have windows 2003 craving book sp2

so should select tie slight repair analogous issues?