Advertisement
Guest User

Untitled

a guest
May 27th, 2016
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.76 KB | None | 0 0
  1. Tomcat Server.xml
  2. ------------------
  3. <Connector connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443" URIEncoding="UTF-8"/>
  4.  
  5. <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8"/>
  6.  
  7.  
  8. Web.xml
  9. --------
  10. <filter>
  11. <filter-name>encodingFilter</filter-name>
  12. <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  13. <init-param>
  14. <param-name>encoding</param-name>
  15. <param-value>UTF-8</param-value>
  16. </init-param>
  17. <init-param>
  18. <param-name>forceEncoding</param-name>
  19. <param-value>true</param-value>
  20. </init-param>
  21. </filter>
  22.  
  23. <filter-mapping>
  24. <filter-name>encodingFilter</filter-name>
  25. <url-pattern>/*</url-pattern>
  26. </filter-mapping>
  27.  
  28.  
  29. <filter>
  30. <filter-name>SetCharacterEncoding</filter-name>
  31. <filter-class>org.apache.catalina.filters.SetCharacterEncodingFilter</filter-class>
  32. <init-param>
  33. <param-name>encoding</param-name>
  34. <param-value>UTF-8</param-value>
  35. </init-param>
  36. </filter>
  37.  
  38. <filter-mapping>
  39. <filter-name>SetCharacterEncoding</filter-name>
  40. <url-pattern>/*</url-pattern>
  41. </filter-mapping>
  42.  
  43.  
  44. HTML-meta tags
  45. --------------
  46. <?xml version="1.0" encoding="UTF-8"?>
  47. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  48. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  49. <html xmlns="http://www.w3.org/1999/xhtml"
  50. xmlns:ui="http://java.sun.com/jsf/facelets"
  51. xmlns:f="http://java.sun.com/jsf/core"
  52. xmlns:h="http://java.sun.com/jsf/html"
  53. xmlns:p="http://primefaces.org/ui">
  54.  
  55. <h:head>
  56. <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
  57. </h:head>
  58.  
  59. JDBC-connection(Datasource)
  60. ---------------------------
  61. <beans:property name="url"
  62. value="jdbc:mysql://localhost:3306/Vehiculos?useUnicode=true&characterEncoding=UTF-8" />
  63.  
  64.  
  65. JDBC-connection(hibernateProperties)
  66. ------------------------------------
  67. <beans:prop key="hibernate.connection.useUnicode">true</beans:prop>
  68. <beans:prop key="hibernate.connection.characterEncoding">UTF-8</beans:prop>
  69. <beans:prop key="hibernate.connection.charSet">UTF-8</beans:prop>
  70.  
  71.  
  72. MySQL database and tables
  73. -------------------------
  74. CREATE DATABASE Vehiculos;
  75.  
  76. CREATE TABLE `Provincias` (
  77. `id` int(11) unsigned NOT NULL,
  78. `nombre` varchar(80) NOT NULL DEFAULT '',
  79. PRIMARY KEY (`id`)
  80. )ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  81.  
  82.  
  83. MySQL server configuration
  84. ---------------------------
  85. [client]
  86. port=3306
  87. default-character-set=utf8
  88.  
  89. [mysql]
  90. default-character-set=utf8
  91.  
  92.  
  93. 1 error insert to table
  94. ------------------------
  95. mysql> INSERT INTO Provincias VALUES (1, 'Álava');
  96. ERROR 1366 (HY000): Incorrect string value: 'xB5lava' for column 'nombre' at row 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement