[The bloke who wrote it][1] was co-head of a [Swedish company][2].

Possibly for similar reasons, Microsoft SQL Server&#39;s default language us_english.


  [1]: http://en.wikipedia.org/wiki/Michael_Widenius
  [2]: http://en.wikipedia.org/wiki/MySQL_AB

`latin1_swedish_ci` is a single byte character set, unlike `utf8_general_ci`.

Compared to `latin1_general_ci` it has support for a variety of extra characters used in European languages. So it’s a best choice if you don’t know what language you will be using, if you are constrained to use only single byte character sets.

I&#39;ve got the following field on an MVC view:

    @Html.TextBoxFor(model =&gt; model.Course.Title, new { data_helptext = &quot;Old Text&quot; })&lt;/span&gt;

In a seperate js file, I want to set the `data-helptext` attribute to a string value. Here&#39;s my code:

    alert($(targetField).data(&quot;helptext&quot;));
            
    $(targetField).data(&quot;helptext&quot;, &quot;Testing 123&quot;);

The `alert()` call works fine, it shows the text &quot;Old Text&quot; in an alert dialog. However, the call to set the `data-helptext` attribute to &quot;Testing 123&quot; does not work. &quot;Old Text&quot; is still the attribute&#39;s current value.

Am I using the call to data() incorrectly? I&#39;ve looked this up on the web, and I can&#39;t see what I&#39;m doing wrong.


Here&#39;s the HTML markup:

    &lt;input data-helptext=&quot;Old Text&quot; id=&quot;Course_Title&quot; name=&quot;Course.Title&quot; type=&quot;text&quot; value=&quot;&quot; /&gt;

Unable to set data attribute using jQuery Data() API

Here&#39;s the information I have:

I am working with a Linux based system using MySQL and PHP5.  I need to be able to generate a `mysqldump` from within a .php file, and then have that dump be stored in a file on the server in a location I would specify.

As I&#39;m a PHP nooblet, I&#39;d like someone to give me some assistance, guidance, or code, that would do what I require. This would have to be run remotely from the Internet.

Using a .php file to generate a MySQL dump

What is the reasoning behind setting `latin1_swedish_ci` as the compiled default when other options seem much more reasonable, like `latin1_general_ci` or `utf8_general_ci`?


Why is MySQL&#39;s default collation latin1_swedish_ci?

<p>What is the reasoning behind setting <code>latin1_swedish_ci</code> as the compiled default when other options seem much more reasonable, like <code>latin1_general_ci</code> or <code>utf8_general_ci</code>?</p>


So far, I have not found a clear answer to this. 

I&#39;d like to know what the equivalent is for a SQL type DATETIME and the java type, using a PreparedStatement.

I have found: http://www.java2s.com/Code/Java/Database-SQL-JDBC/StandardSQLDataTypeswithTheirJavaEquivalents.htm

But it states that SQL type &quot;DATETIME&quot; is the same as sql.date, but when looking at the SQL date docs (http://download.oracle.com/javase/7/docs/api/java/sql/Date.html), it says the time is truncated (all zeros).

What I want is to be able to specify a `preparedStatement.setDateTime()` or some sort.

The only other way I see is using a timestamp, but that would require me to change the column type, while I cannot imagine someone else never had this problem before?

Any hints?

Edit: I am using MYSQL.

A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

For example - I create database  and a table from cli and insert some data:

    CREATE DATABASE testdb CHARACTER SET &#39;utf8&#39; COLLATE &#39;utf8_general_ci&#39;;
    USE testdb;
    CREATE TABLE test (id INT, str VARCHAR(100)) TYPE=innodb CHARACTER SET &#39;utf8&#39; COLLATE &#39;utf8_general_ci&#39;;
    INSERT INTO test VALUES (9, &#39;some string&#39;);


Now I can do this and these examples do work (so - quotes don&#39;t affect anything it seems):

    SELECT * FROM test WHERE id = &#39;9&#39;;
    INSERT INTO test VALUES (&#39;11&#39;, &#39;some string&#39;);

So - in these examples I&#39;ve selected a row by a **string** that actually stored as INT in mysql and then I inserted a **string** in a column that is INT.

I don&#39;t quite get why this works the way it works here. Why is string allowed to be inserted in an INT column?

Can I insert all MySQL data types as strings?

Is this behavior standard across different RDBMS?


In MySQL, should I quote numbers or not?

I have a database table that contains Swedish/Norwegian strings.

When I query some data, I get output like this:

## Output with `set names latin1;`

	+-----------------------------------+
	| name                              |
	+-----------------------------------+
	| Kid Interi#####                   | 
	| Bwg Homes                         | 
	| If Skadef####kring                | 
	| Jangaard Export                   | 
	| Nordisk Film                      | 
	+-----------------------------------+

Now if I `set names utf8;` in order to see the characters with their proper encoding, then the formatting of the tabular output of the MySQL command line breaks.

## Output with `set names utf8;`

	+-----------------------------------+
	| name                              |
	+-----------------------------------+
	| Kid Interi&#248;r                     | 
	| Bwg Homes                         | 
	| If Skadef&#246;rs&#228;kring              | 
	| Jangaard Export                   | 
	| Nordisk Film                      | 
	+-----------------------------------+

## Question:
This is not a big issue but it makes the output a bit harder to read. Does anybody know how to keep the tabular formatting intact?





MySQL command line formatting with UTF8

I have a date field in php which is using this code: 

    $date = mysql_real_escape_string($_POST[&#39;intake_date&#39;]);

How do I convert this to MySql format 0000-00-00 for inclusion in db. Is it along the lines of: date(&#39;Y-m-d&#39; strtotime($date);. The reason I ask, is because I have tried variations of this and I cannot seem to get it to work. Either displays as 1970 or some other variation of that. Many thanks

convert php date to mysql format

Currently I am having the following MySQL table: `Employees (empID, empName, department);`

I want to change the table to the following: `Employees (empID, department, empName);`

How can this be done using `ALTER` statements?

Note: I want to change only column positions. 

How to move columns in a MySQL table?

I previously created a MySQL table and now I want to find out what collation some of the fields are using. What SQL or MySQL commands can I use to discover this?



Discover collation of a MySQL column

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I get the following error

&gt; Cannot resolve the collation conflict between &quot;SQL_Latin1_General_CP1_CI_AS&quot; and &quot;Latin1_General_CI_AS&quot; in the equal to operation

I changed the collation on the database using 

    ALTER DATABASE [optimiser] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    ALTER DATABASE [optimiser] COLLATE SQL_Latin1_General_CP1_CI_AS
    ALTER DATABASE [optimiser] SET MULTI_USER

But I still get the error whenever the stored procedures run. I believe because the SP is using a join to another database (GE&#39;s ihistorian) and it has a collation mismatch. IS there anyway to resolve this.

On the old server DB1 was set as `Latin1_General_CI_AS` and this works fine. The new location for the DB has a default of `SQL_Latin1_General_CP1_CI_AS`. Is it worth changing the collation n DB1 on the new server back to `Latin1_General_CI_AS`??

Cannot Resolve Collation Conflict

I am working on a view, wherein I am using an inner join on two tables which are from two different servers. We are using linked server. When running the query I am getting this message:

&gt;    Cannot resolve the collation conflict between &quot;SQL_Latin1_General_CP1_CI_AS&quot; and &quot;Arabic_CI_AS&quot; in the equal to operation.

I don&#39;t know much about collation. Searching through internet I find solutions to use `COLLATE`, but the concept of `COLLATE` is not clear to me. Will it change anything for any of the databases? I am looking for a solution without changing anything for the databases.

Any good learning material for these concepts is welcome.

How to fix a collation conflict in a SQL Server query?

I have a WordPress website on my local **WAMP** server. But when I upload its database to live server, I get error 

    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Any help would be appreciated!

Content Type	Original Author	Original Content on Stackoverflow
Question	Alan	View Question on Stackoverflow
Solution 1 - Mysql	gbn	View Answer on Stackoverflow
Solution 2 - Mysql	Ariel	View Answer on Stackoverflow

Why is MySQL's default collation latin1_swedish_ci?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Using a .php file to generate a MySQL dump

Unable to set data attribute using jQuery Data() API

Attributions