Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Java > JavaBase > body text

Solution to garbled database data in java

尚

Release： 2019-12-05 11:54:13

Original

2647 people have browsed it

Solution to garbled database data in java

Java database garbled solution:

1. When creating the database:

CREATE   DATABASE   `Db` 
CHARACTER   SET   &#39;utf8 &#39; 
COLLATE   &#39;utf8_general_ci &#39;;

Copy after login

2. When creating the table:

CREATE   TABLE   `TableA`   ( 
                 `ID`   varchar(40)   NOT   NULL   default   &#39; &#39;, 
                  `UserID`   varchar(40)   NOT   NULL   default   &#39; &#39;,  ) 
                    ENGINE=InnoDB   DEFAULT   CHARSET=utf8;

Copy after login

3. When setting the URL:

jdbc:mysql://localhost:3306/database?useUnicode=true&amp;characterEncoding=UTF-8

Copy after login

For more java knowledge, please pay attention to java basic tutorial.

The above is the detailed content of Solution to garbled database data in java. For more information, please follow other related articles on the PHP Chinese website!

Related labels：

java

source：php.cn

Previous article：How to determine whether an array contains an element in java Next article：How to determine whether a string is in date format in java

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn