MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 30th, 2004, 10:03 AM
Slain84 Slain84 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 2 Slain84 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Outputted cyrillic text is displayed wrong

Hello,

I searched a long time for an answer to my question, but I have not found a satisfying one yet... And I really do not know if it is a SQL-Server problem or a PHP problem so I postet this thread in both, the SQL-Server and the PHP, forums.

I save cyrillic texts in a Microsoft SQL-Server database. No problem at all.

I connect to the database via ODBC as it is with PHP not possible to read a ntext field from the database. Data is read out correctly in german or english and displayed correctly as well.

But when I change the language to Russia which means that the cyrillic texts are read out, only "???" appears (see attachment).

Has anobody ever dealt with this problem?

In my HTML-file there is the following tag when the russia language is chosen:

Code:
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=windows-1251">


Thank you very much for your answers.

Greetings, Dominik
Attached Images
File Type: jpg cyrrilic.jpg (96.1 KB, 171 views)

Last edited by Slain84 : March 30th, 2004 at 10:14 AM.

Reply With Quote
  #2  
Old May 26th, 2004, 05:58 AM
mangotree mangotree is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 1 mangotree User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
you need to add a header to you output.

before you send the html back to your user add this

<?php header ("Content-Type: text/html; charset=windows-1251"); ?>


having the same fun problems myself :-)

Reply With Quote
  #3  
Old January 4th, 2005, 02:27 AM
dmd dmd is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 1 dmd User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Asp

I have same problem with ASP, please tell me how to solve this problem in ASP Page.

Thank You !

Reply With Quote
  #4  
Old July 17th, 2012, 04:07 AM
pcinja pcinja is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2012
Posts: 1 pcinja User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 22 sec
Reputation Power: 0
You must put the next row after the connection row:
mysqli_set_charset($this->link, "utf8");
Then you put in the head of your HTML page this row:
<metahttp-equiv="Content-Type" content="text/html; charset=utf-8">

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > Outputted cyrillic text is shown wrong

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap