Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Connector port="8080" maxHttpHeaderSize="8192"
- maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
- enableLookups="false" redirectPort="8443" acceptCount="100"
- connectionTimeout="20000" disableUploadTimeout="true"
- compression="on"
- compressionMinSize="128"
- noCompressionUserAgents="gozilla, traviata"
- compressableMimeType="text/html,text/xml,text/plain,text/css,text/ javascript,application/x-javascript,application/javascript"
- URIEncoding="UTF-8"
- />
- https://localhost:8443/ID/Users?action=search&name=*ж*
- package fi.foo.filters;
- import java.io.IOException;
- import javax.servlet.Filter;
- import javax.servlet.FilterChain;
- import javax.servlet.FilterConfig;
- import javax.servlet.ServletException;
- import javax.servlet.ServletRequest;
- import javax.servlet.ServletResponse;
- public class CharsetFilter implements Filter
- {
- private String encoding;
- public void init(FilterConfig config) throws ServletException
- {
- encoding = config.getInitParameter("requestEncoding");
- if( encoding==null ) encoding="UTF-8";
- }
- public void doFilter(ServletRequest request, ServletResponse response, FilterChain next)
- throws IOException, ServletException
- {
- // Respect the client-specified character encoding
- // (see HTTP specification section 3.4.1)
- if(null == request.getCharacterEncoding())
- request.setCharacterEncoding(encoding);
- /**
- * Set the default response content type and encoding
- */
- response.setContentType("text/html; charset=UTF-8");
- response.setCharacterEncoding("UTF-8");
- next.doFilter(request, response);
- }
- public void destroy(){}
- }
- <!--CharsetFilter start-->
- <filter>
- <filter-name>CharsetFilter</filter-name>
- <filter-class>fi.foo.filters.CharsetFilter</filter-class>
- <init-param>
- <param-name>requestEncoding</param-name>
- <param-value>UTF-8</param-value>
- </init-param>
- </filter>
- <filter-mapping>
- <filter-name>CharsetFilter</filter-name>
- <url-pattern>/*</url-pattern>
- </filter-mapping>
- <%@page pageEncoding="UTF-8" contentType="text/html; charset=UTF-8"%>
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fi">
- <head>
- <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
- ...
- <Resource name="jdbc/AppDB"
- auth="Container"
- type="javax.sql.DataSource"
- maxActive="20" maxIdle="10" maxWait="10000"
- username="foo"
- password="bar"
- driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/ ID_development?useEncoding=true&characterEncoding=UTF-8"
- />
- CREATE DATABASE `ID_development`
- /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_swedish_ci */;
- CREATE TABLE `Users` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(30) collate utf8_swedish_ci default NULL
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci ROW_FORMAT=DYNAMIC;
- [client]
- port=3306
- default-character-set=utf8
- [mysql]
- default-character-set=utf8
- DELIMITER $$
- DROP FUNCTION IF EXISTS `pathToNode` $$
- CREATE FUNCTION `pathToNode` (ryhma_id INT) RETURNS TEXT CHARACTER SET utf8
- READS SQL DATA
- BEGIN
- DECLARE path VARCHAR(255) CHARACTER SET utf8;
- SET path = NULL;
- ...
- RETURN path;
- END $$
- DELIMITER ;
- https://localhost:8443/ID/Users?action=search&name=Petteri
- https://localhost:8443/ID/Users?action=search&name=ж
- https://localhost:8443/ID/Users?action=search&name=*Päivi*
- https://localhost:8443/ID/Users?action=search&name=*P%E4ivi*
- <connection-url>jdbc:mysql://192.168.10.123:3308/mydatabase</connection-url>
- <driver-class>com.mysql.jdbc.Driver</driver-class>
- <user-name>nts</user-name>
- <password>xaxaxa!</password>
- <connection-property name="useUnicode">true</connection-property>
- <connection-property name="characterEncoding">greek</connection-property>
- jdbc:mysql://192.168.10.123:3308/mydatabase?characterEncoding=greek
- <%@page contentType="text/html"%>
- <%@page pageEncoding="UTF-8"%>
- convmv --notest -f cp1252 -t utf8 * -r
- DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- Connection conn = DriverManager.getConnection(
- "jdbc:mysql://192.168.1.12:3308/mydb?characterEncoding=greek",
- "Myuser", "mypass");
- DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- Connection conn = DriverManager.getConnection(("jdbc:mysql://192.168.1.1:3308/nts?characterEncoding=greek","myuser","mypass");
Add Comment
Please, Sign In to add comment