Hello, guys
I have a problem with collation in MySQL. In phpadmin I can see normaly my data without ????? but when I trying to extract data from my table "invoice" in txt file I get ??????. What is wrong?
I use :
MySQL connection collation - utf8_bin
database - utf8_general_ci ( here when I configure utf8_general or utf8_unicode or something else the data in table invoice are with ??????? , that's why I configure cp1251_general_ci
table - utf8_bin
I use this code to extract data from my database
[/code]
<?php header("Content-Type: text/html; charset=UTF-8"); ?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<?php
$invoice_id = $REQUEST['invoice_id'];
$folder_num = $REQUEST['folder_num'];
$date_doc = $REQUEST['date_doc'];
$comment = $REQUEST['comment'];
$sql = mysql_connect("localhost", "*", "**");
mysql_select_db("export") or die(mysql_error());
$data = mysql_query("SELECT FROM invoice WHERE ID_PURCHASE_INVOICE = '$invoice_id'")
or die(mysql_error());
$filewrite = fopen("myfile-random.txt", "w");
while($row = mysql_fetch_array( $data, MYSQL_ASSOC ))
{
fwrite($filewrite, "ОПДДС" . "@@");
fwrite($filewrite, $row['ID_PURCHASE_INVOICE'] . "#");
fwrite($filewrite, $row['DOC_DATE'] . "#");
fwrite($filewrite, $folder_num . "#");
fwrite($filewrite, "201##987" . "#");
fwrite ($filewrite, $date_doc . "#");
fwrite($filewrite, $row['DOC_TYPE_NAME'] . "#####");
fwrite ($filewrite, $comment . "#");
fwrite($filewrite, $row['DOC_NUM'] . "#");
}
/
$data1 = mysql_query("SELECT FROM delivery_head WHERE ID_PURCHASE_INVOICE = '$invoice_id'")
or die(mysql_error());
$filewrite1 = fopen("myfile-random.txt", "a");
while($row = mysql_fetch_array( $data1, MYSQL_ASSOC ))
{
fwrite($filewrite1, $row['DELIVERY_DATE'] ."#" );
}
*/
?>
[/code]
