arabic text is saved as unreadable characters - Database Discussion Boards

First result on Google for "MySql Windows Silent Install":

https://dev.mysql.com/doc/refman/5.1/en/windows-installer-msi-quiet.html[^]

For example, to perform a quiet installation (which shows no dialog boxes or progress):
msiexec /i mysql-5.1.73.msi /quiet

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

what about the configuration setting such as windows service name, port, password, etc. I mean the screen which pops up after the installation. how can I run it in a Quiet! mode?

Technology News @ www.JassimRahma.com

if you had followed Richard's post, and read the article, you'd also have seen this

https://dev.mysql.com/doc/refman/5.1/en/mysql-config-wizard-cmdline.html[^]

'g'

Thanks

Technology News @ www.JassimRahma.com

Just noting that if your intent is that your application will be doing all of the database administration then choosing a database that is less full featured might be a better option. And choosing an embedded database might be a better option as well.

I am currently running mssql 2008 SSRS on hosting server and whenever I view my report on chrome browser my report shrinks to 25% of the total page width. Please what do I need to do?

Kenny

Refer

ssrs-reports-browser-compatability-issues[^]

Hope it will help.. Smile | :)

Hi,

I am having a problem saving from my php for to MySQL database. I am not sure if the problem is at the PHP level or database level.

here is the form:

http://www.jassimrahma.com/contactme[^]

and when submiting arabic characters... it will be saved as unreadable characters like this:

http://www.jassimrahma.com/arabic.png[^]

My database character set is UTF-8 Unicode and Collation is utf8_general_ci

here is my table DDL:

CREATE TABLE `mubadara_messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_from_name` varchar(255) DEFAULT NULL,
  `message_from_email` varchar(255) DEFAULT NULL,
  `message_subject` varchar(255) DEFAULT NULL,
  `message_body` text,
  `message_ip_address` varchar(255) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

and this is my PHP:

PHP

require 'PHPMailer/class.phpmailer.php';

$message_visitor_name = $_POST['txtName'];
$message_visitor_email = $_POST['txtEmail'];
$message_subject = $_POST['txtSubject'];
$message_body = $_POST['txtMessage'];
$message_ip_address = $_SERVER['REMOTE_ADDR'];

// save the message
$mysql_connection = mysql_connect('mysql.jassimrahma.com', 'jassimdb', 'Mujtaba2013');
mysql_select_db('jassimrahma_com', $mysql_connection);

// $mysql_connection = mysql_connect('localhost', 'root', 'xxxxxxxxxxxx');
// mysql_select_db('jassimrahma', $mysql_connection);

$mysql_command = "INSERT INTO mubadara_messages (message_from_name, message_from_email, message_subject, message_body, message_ip_address) VALUES ('$message_visitor_name', '$message_visitor_email', '$message_subject', '$message_body', '$message_ip_address')";
$mysql_result = mysql_query($mysql_command, $mysql_connection) or die(mysql_error());
// $mysql_result = mysql_query("SELECT project_name FROM projects WHERE project_id = 13");
// echo $mysql_result;
mysql_close($mysql_connection);

exit(header("Location: thankyou"));

can anyone help please

Thanks,
Jassim

Technology News @ www.JassimRahma.com

modified 6-Mar-14 5:57am.

Not sure. You might need to add a

PHP

mysql_set_charset('utf8');

between the connection and the selection of the db.

Hi,
    I want to know if there is any way to retrieve an entire row that has a column with least creation time without using top.

Let us take a sample table named Patient
-----------------------------------------------------------
PatientId  Observation    Time                    Value
-----------------------------------------------------------
1          Temp           2014-02-19 03:55:00     35
1          Temp           2014-02-19 03:45:00     37
1          Weight         2014-02-19 03:40:00     60
 
If i am given the PatientId and Observation, I need to retrieve the the row with minimum creation time
For patient id 1 and  observation Temp this would be the row
1         Temp           2014-02-19 03:45:00     37
since it has 2014-02-19 03:45:00 as minimum creation time

SQL

WITH FirstObservation AS (
    SELECT  PatientID,Observation,Min(Time) Time
    FROM    MyTable
    WHERE   PatientID = @PatientID
    AND     Observation = @Observation
    GROUP BY PatientID,Observation
    )
SELECT  PatientId,Observation,TIME,Value
FROM    MyTable m
JOIN    FirstObservation f
ON      m.PatientID = f.PatientID
AND     m.Observation = f.Observation
AND     m.Time = f.Time

Wrong is evil and must be defeated.
- Jeff Ello[^]

Why not using order by and top? Because that is can be fast and effective, specially when you have an index on time column?
Or just because it's an exercise you got at school?

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Kornfeld Eliyahu Peter wrote:
Why not using order by and top?

Just a guess; "it's too slow"

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

And nested select not? It's performance depends only on the proper indexing...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Kornfeld Eliyahu Peter wrote:
And nested select not?

I did not say that Smile | :)

Kornfeld Eliyahu Peter wrote:
It's performance depends only on the proper indexing...

..and the amount of records, the amount of fields in a row, their size, and the speed of the harddisk.

Ya reckon there's an index on the date? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:
and the amount of records, the amount of fields in a row, their size

Not quiet right... With indexed table there will be two page reads only (and if the index clustered only one), not matter what size the table is...

Eddy Vluggen wrote:
Ya reckon there's an index on the date

I do not think there is a table at all - it sound me like a school exercise...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Damn you Eddy you made try to learn something today!

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Maybe it's just not for an SQLserver. If you want a generic query TOP is out of the question.

Wrong is evil and must be defeated.
- Jeff Ello[^]

Create a table called "Cheater", containing both PatientId and last updatetime. Set both from a trigger on the Patient-table - do an insert of it doesn't contain the patient-Id, otherwise simply update the time.

Index the table on time, id.

You now have an indexed int/date table for your lookup.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Hi,

I am a user of MySql. In Mysql we can go for the query

select * from Patient where time=(select max(time) from Patient);

Hope it will work for you. Check n update.

Hello,
i have two user schemas.
Let's Say A & B.
A has a procedure written in it SAY 'XProc'.

B has a package which has Procedure say 'B_Pack_Proc', which creates a dynamic view in B user schema.

The B_pack_proc creates view in B schema itself.

but i am executing the B_Pack_Pro from A, i am getting error insufficient privileges.

I am using oracle forms 11g and oracle DB 11g.

i have granted explicit grants to User A from User B
i.e Create any view
Execute on view.

please help.

-
Prathamesh

Have you given user A privileges to execute the package?

SQL

GRANT EXECUTE ON B.packagename TO A;

Wrong is evil and must be defeated.
- Jeff Ello[^]

i have explicitly granted permission on the view, package and the tables in the views.
still not working

-
Prathamesh

What's the exact error message?

Wrong is evil and must be defeated.
- Jeff Ello[^]

I created a table in ms access, and then i wanted to connect it to a java gui front end using type 1 driver. so i tried to create an odbc dsn for access. the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.