Commit9a26419

committed

Doc: explain that the string types can't store \0 (ASCII NUL).

This restriction was mentioned in connection with string literals,but it wasn't made clear that it's a general restriction not justa syntactic limitation in query strings.Per unsigned documentation comment.Discussion:https://postgr.es/m/160720552914.710.16625261471128631268@wrigleys.postgresql.org

1 parente2ac3fe commit9a26419Copy full SHA for 9a26419

File tree

-4

lines changed

-4

lines changed

Lines changed: 9 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1209,6 +1209,14 @@ SELECT '52093.89'::money::numeric::float8;`
`1209`	`1209`	`regular expressions.`
`1210`	`1210`	`</para>`
`1211`	`1211`
	`1212`	`+ <para>`
	`1213`	`+ The characters that can be stored in any of these data types are`
	`1214`	`+ determined by the database character set, which is selected when`
	`1215`	`+ the database is created. Regardless of the specific character set,`
	`1216`	`+ the character with code zero (sometimes called NUL) cannot be stored.`
	`1217`	`+ For more information refer to <xref linkend="multibyte"/>.`
	`1218`	`+ </para>`
	`1219`	`+`
`1212`	`1220`	`<para>`
`1213`	`1221`	`The storage requirement for a short string (up to 126 bytes) is 1 byte`
`1214`	`1222`	`plus the actual string, which includes the space padding in the case of`
`@@ -1246,10 +1254,7 @@ SELECT '52093.89'::money::numeric::float8;`
`1246`	`1254`	`<para>`
`1247`	`1255`	`Refer to <xref linkend="sql-syntax-strings"/> for information about`
`1248`	`1256`	`the syntax of string literals, and to <xref linkend="functions"/>`
`1249`		`- for information about available operators and functions. The`
`1250`		`- database character set determines the character set used to store`
`1251`		`- textual values; for more information on character set support,`
`1252`		`- refer to <xref linkend="multibyte"/>.`
	`1257`	`+ for information about available operators and functions.`
`1253`	`1258`	`</para>`
`1254`	`1259`
`1255`	`1260`	`<example>`

Comments

(0)